{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Invoerblad","Uitslagformulier"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoerblad","index":0,"n_rows":45,"n_cols":45,"rows_kept":45,"cut":false,"hidden":false,"merged":[[26,14,26,16],[10,4,10,5],[41,1,41,2],[42,1,42,2],[20,14,20,16],[35,2,35,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[40,1,40,2],[34,2,34,3],[1,4,1,5],[2,4,2,5],[16,2,16,3],[3,4,3,5],[38,10,38,12],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[33,2,33,3],[4,23,4,25],[15,1,15,2],[0,6,0,8],[1,6,1,8],[2,6,2,8],[3,6,3,8],[5,5,5,8],[5,1,5,4],[10,14,10,16],[11,4,11,5],[12,4,12,5],[15,14,15,16],[8,1,9,1],[8,2,9,3],[8,4,9,5],[0,4,0,5]]}
[null,null,null,null,"Voorronde PK:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Data:"]
[null,null,null,null,"Locatie:"]
[null,null,null,null,"Wedstrijdleider:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schema 3 personen"]
[null,"NAMEN INVULLEN VOLGORDE UITNODIGING",null,null,null,"UITSLUITEND DE GELE VLAKKEN INVULLEN !",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"-",3]
[null,"Deelnemers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",3]
[null,"Bondsnr","Naam",null,"Vereniging",null,"te maken","aanvangs","Oficieel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",2]
[null,null,null,null,null,null,"car.","moy.","moyenne",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"-",3]
[1,null," ",null,null,null,null," "," ",null,null,null,null,null,"aantal partijen gespeeld",null,null,null,null,null,null,null,null,1,"-",3]
[2,null," ",null,null,null,null," "," ",null,null,null,1,{"$f":"IF(F18>0,1,FALSE)","v":1},{"$f":"IF(F24>0,1,FALSE)","v":1},{"$f":"IF(F29>0,1,FALSE)","v":1},{"$f":"IF(F35>0,1,FALSE)","v":1},{"$f":"SUM(N12:Q12)","v":4},{"$f":"PRODUCT(G11,R12)","v":4}]
[3,null," ",null,null,null,null," "," ",null,null,null,2,{"$f":"IF(F19>0,1,FALSE)","v":1},{"$f":"IF(F21>0,1,FALSE)","v":1},{"$f":"IF(F30>0,1,FALSE)","v":1},{"$f":"IF(F32>0,1,FALSE)","v":1},{"$f":"SUM(N13:Q13)","v":4},{"$f":"PRODUCT(G12,R13)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(F22>0,1,FALSE)","v":1},{"$f":"IF(F25>0,1,FALSE)","v":1},{"$f":"IF(F33>0,1,FALSE)","v":1},{"$f":"IF(F36>0,1,FALSE)","v":1},{"$f":"SUM(N14:Q14)","v":4},{"$f":"PRODUCT(G13,R14)","v":4}]
[]
[null,"Wedstrijden",null,null,null,null,null,null,null,null,null,null,null,null,"% moyenne"]
[null,null,"Naam",null,"Car.","Brt.","HS","Moy.","Pnt.",null,null,null,1,{"$f":"IF(I18>0,H18,0)","v":0},{"$f":"IF(I24>0,H24,0)","v":0},{"$f":"IF(I29>0,H29,0)","v":0},{"$f":"IF(I35>0,H35,0)","v":0},{"$f":"MAX(N17:Q17)","v":0}]
[null,null,{"$f":"C11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(E18/F18,3)","v":{"$error":"#VALUE!"}},{"$f":"V18","v":0},null,null,null,2,{"$f":"IF(I19>0,H19,0)","v":0},{"$f":"IF(I21>0,H21,0)","v":0},{"$f":"IF(I30>0,H30,0)","v":0},{"$f":"IF(I32>0,H32,0)","v":0},{"$f":"MAX(N18:Q18)","v":0},null,{"$f":"IF(E18=G11,1,0)","v":0},{"$f":"IF(E19<G12,1,0)","v":0},{"$f":"SUM(T18:U18)","v":0}]
[null,null,{"$f":"C12","v":" "},null," ",{"$f":"F18","v":" "}," ",{"$error":"#VALUE!"},{"$f":"V19","v":0},null,null,null,3,{"$f":"IF(I22>0,H22,0)","v":0},{"$f":"IF(I25>0,H25,0)","v":0},{"$f":"IF(I33>0,H33,0)","v":0},{"$f":"IF(I36>0,H36,0)","v":0},0,null,{"$f":"IF(E19=G12,1,0)","v":0},{"$f":"IF(E18<G11,1,0)","v":0},{"$f":"SUM(T19:U19)","v":0}]
[]
[null,null,{"$f":"C12","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(E21/F21,3)","v":{"$error":"#VALUE!"}},{"$f":"V21","v":0},null,null,null,null,null,"partijen gewonnen",null,null,null,null,{"$f":"IF(E21=G12,1,0)","v":0},{"$f":"IF(E22<G13,1,0)","v":0},{"$f":"SUM(T21:U21)","v":0}]
[null,null,{"$f":"C13","v":" "},null," ",{"$f":"F21","v":" "}," ",{"$error":"#VALUE!"},{"$f":"V22","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E22=G13,1,0)","v":0},{"$f":"IF(E21<G12,1,0)","v":0},0]
[null,null,null,null," ",null,null,null,null,null,null,null,1,{"$f":"IF(I18>1,1,0)","v":0},{"$f":"IF(I24>1,1,0)","v":0},{"$f":"IF(I29>1,1,0)","v":0},{"$f":"IF(I35>1,1,0)","v":0},{"$f":"SUM(N23:Q23)","v":0}]
[null,null,{"$f":"C11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(E24/F24,3)","v":{"$error":"#VALUE!"}},{"$f":"V24","v":0},null,null,null,2,{"$f":"IF(I19>1,1,0)","v":0},{"$f":"IF(I21>1,1,0)","v":0},{"$f":"IF(I30>1,1,0)","v":0},{"$f":"IF(I32>1,1,0)","v":0},{"$f":"SUM(N24:Q24)","v":0},null,{"$f":"IF(E24=G11,1,0)","v":0},{"$f":"IF(E25<G13,1,0)","v":0},0]
[null,null,{"$f":"C13","v":" "},null," ",{"$f":"F24","v":" "}," ",{"$error":"#VALUE!"},{"$f":"V25","v":0},null,null,null,3,{"$f":"IF(I22>1,1,0)","v":0},{"$f":"IF(I25>1,1,0)","v":0},{"$f":"IF(I33>1,1,0)","v":0},{"$f":"IF(I36>1,1,0)","v":0},{"$f":"SUM(N25:Q25)","v":0},null,{"$f":"IF(E25=G13,1,0)","v":0},{"$f":"IF(E24<G11,1,0)","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partijen gelijk"]
[null,null,"Naam",null,"Car.","Brt.","Hs","Moy.","Pnt."]
[null,null,{"$f":"C11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(E29/F29,3)","v":{"$error":"#VALUE!"}},{"$f":"V29","v":0},null,null,null,1,{"$f":"IF(I18=1,1,0)","v":0},{"$f":"IF(I24=1,1,0)","v":0},{"$f":"IF(I35=1,1,0)","v":0},{"$f":"IF(I35=1,1,0)","v":0},{"$f":"SUM(N29:Q29)","v":0},null,{"$f":"IF(E29=G11,1,0)","v":0},{"$f":"IF(E30<G12,1,0)","v":0},0]
[null,null,{"$f":"C12","v":" "},null," ",{"$f":"F29","v":" "}," ",{"$error":"#VALUE!"},{"$f":"V30","v":0},null,null,null,2,{"$f":"IF(I19=1,1,0)","v":0},{"$f":"IF(I21=1,1,0)","v":0},{"$f":"IF(I30=1,1,0)","v":0},{"$f":"IF(I32=1,1,0)","v":0},{"$f":"SUM(N30:Q30)","v":0},null,{"$f":"IF(E30=G12,1,0)","v":0},{"$f":"IF(E29<G11,1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(I22=1,1,0)","v":0},{"$f":"IF(I25=1,1,0)","v":0},{"$f":"IF(I33=1,1,0)","v":0},{"$f":"IF(I36=1,1,0)","v":0},{"$f":"SUM(N31:Q31)","v":0}]
[null,null,{"$f":"C12","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(E32/F32,3)","v":{"$error":"#VALUE!"}},{"$f":"V32","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E32=G12,1,0)","v":0},{"$f":"IF(E33<G13,1,0)","v":0},{"$f":"SUM(T32:U32)","v":0}]
[null,null,{"$f":"C13","v":" "},null," ",{"$f":"F32","v":" "}," ",{"$error":"#VALUE!"},{"$f":"V33","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E33=G13,1,0)","v":0},{"$f":"IF(E32<G12,1,0)","v":0},0]
[]
[null,null,{"$f":"C11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(E35/F35,3)","v":{"$error":"#VALUE!"}},{"$f":"V35","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E35=G11,1,0)","v":0},{"$f":"IF(E36<G13,1,0)","v":0},0]
[null,null,{"$f":"C13","v":" "},null," ",{"$f":"F35","v":" "}," ",{"$error":"#VALUE!"},{"$f":"V36","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E36=G13,1,0)","v":0},{"$f":"IF(E35<G11,1,0)","v":0},0]
[]
[]
[null,"Stand",null,null,null,null,null,null,null,null,"Plaatsing ",null,null,"Rangking"]
[null,null,null,"Car.","Brt.","HS","Moy.","Pnt.","% moy.","% carb.","Mp.","% moy.","% carb."]
[null,{"$f":"C11","v":" "},null,{"$f":"SUM(E18,E24,E29,E35)","v":0},{"$f":"SUM(F18,F24,F29,F35)","v":0},{"$f":"MAX(G18,G24,G29,G35)","v":0},{"$f":"ROUNDDOWN(D41/E41,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I18,I24,I29,I35)","v":0},{"$f":"IF(OR(ISBLANK(D41),ISBLANK(E41)),\"-\",IF(AND(I11=\"NEE\",G41/H11>1),100,ROUNDDOWN(G41/H11%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D41/S12","v":0},null,null,null,{"$f":"SUM(K41:M41)","v":0}]
[null,{"$f":"C12","v":" "},null,{"$f":"SUM(E19,E21,E30,E32)","v":0},{"$f":"SUM(F19,F21,F30,F32)","v":0},{"$f":"MAX(G19,G21,G30,G32)","v":0},{"$f":"ROUNDDOWN(D42/E42,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19,I21,I30,I32)","v":0},{"$f":"IF(OR(ISBLANK(D42),ISBLANK(E42)),\"-\",IF(AND(I12=\"NEE\",G42/H12>1),100,ROUNDDOWN(G42/H12%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D42/S13","v":0},null,null,null,{"$f":"SUM(K42:M42)","v":0}]
[null,{"$f":"C13","v":" "},null,{"$f":"SUM(E22,E25,E33,E36)","v":0},{"$f":"SUM(F22,F25,F33,F36)","v":0},{"$f":"MAX(G22,G25,G33,G36)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(I22,I25,I33,I36)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Uitslagformulier","index":1,"n_rows":94,"n_cols":16,"rows_kept":94,"cut":false,"hidden":false,"merged":[[2,12,2,14],[17,9,17,10],[1,1,1,4],[1,5,1,9],[30,7,30,8],[8,7,8,9],[9,7,9,9],[29,7,29,8],[17,0,17,3],[18,0,18,3],[20,0,20,3],[18,9,23,10],[17,5,17,7],[8,3,8,6],[9,3,9,6],[21,0,21,3],[22,0,22,3],[32,7,32,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[31,7,31,8],[23,0,23,3],[24,0,24,3],[18,5,18,8],[24,5,24,8],[19,5,19,8],[20,5,20,8],[21,5,21,8],[22,5,22,8],[23,5,23,8]]}
[]
[null,"Uitslagformulier voorronden ",null,null,null,{"$f":"Invoerblad!G1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plaatsing "]
[null,"Bondsnr.","Naam","Gew.","Remise","Carb.","Brt.","HS.","Pnt.","Moyenne","% moy.","% carb.","Mp.","% moy.","% carb.","Rangking"]
[1,{"$f":"Invoerblad!B11","v":0},{"$f":"Invoerblad!C11","v":" "},{"$f":"Invoerblad!R23","v":0},{"$f":"Invoerblad!R29","v":0},{"$f":"Invoerblad!D41","v":0},{"$f":"Invoerblad!E41","v":0},{"$f":"Invoerblad!F41","v":0},{"$f":"Invoerblad!H41","v":0},{"$f":"Invoerblad!G41","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I41/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J41","v":0},{"$f":"Invoerblad!K41","v":0},{"$f":"Invoerblad!L41","v":0},{"$f":"Invoerblad!M41","v":0},{"$f":"SUM(M5:O5)","v":0}]
[2,{"$f":"Invoerblad!B12","v":0},{"$f":"Invoerblad!C12","v":" "},{"$f":"Invoerblad!R24","v":0},{"$f":"Invoerblad!R30","v":0},{"$f":"Invoerblad!D42","v":0},{"$f":"Invoerblad!E42","v":0},{"$f":"Invoerblad!F42","v":0},{"$f":"Invoerblad!H42","v":0},{"$f":"Invoerblad!G42","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I42/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J42","v":0},{"$f":"Invoerblad!K42","v":0},{"$f":"Invoerblad!L42","v":0},{"$f":"Invoerblad!M42","v":0},{"$f":"SUM(M6:O6)","v":0}]
[3,{"$f":"Invoerblad!B13","v":0},{"$f":"Invoerblad!C13","v":" "},{"$f":"Invoerblad!R25","v":0},{"$f":"Invoerblad!R31","v":0},{"$f":"Invoerblad!D43","v":0},{"$f":"Invoerblad!E43","v":0},{"$f":"Invoerblad!F43","v":0},{"$f":"Invoerblad!H43","v":0},{"$f":"Invoerblad!G43","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I43/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J43","v":0},{"$f":"Invoerblad!K43","v":0},{"$f":"Invoerblad!L43","v":0},{"$f":"Invoerblad!M43","v":0},0]
[]
[null,null,null,"Naam vereniging",null,null,null,"Datum"]
[null,null,null,{"$f":"Invoerblad!G3","v":0},null,null,null,{"$f":"TODAY()","v":"2023-11-14"}]
[]
["DIT FORMULIER DUIDELIJK INGEVULD EN VOORZIEN VAN DE HANDTEKENING "]
[]
["VAN EEN LID VAN DE ORGANISERENDE VERENIGING           BINNEN 3 DAGEN "]
[]
["NA AFLOOP VAN DE VOORWEDSTRIJDEN TOEZENDEN OF MAILEN AAN:  "]
[null,"﻿ "]
["Met vriendelijke groet",null,null,null,null,"Met vriendelijke groet",null,null,null,"handtekening:"]
["Wedstrijdleider PK",null,null,null,null,"Wedstrijdleider PK driebanden",null,null,null,{"$f":"Invoerblad!G4","v":0}]
[]
["Johan Jansink",null,null,null,null,"Marco Ubbink"]
["Veemarkt 11",null,null,null,null,"Molenkamp 6"]
["7121 AH  Aalten",null,null,null,null,"7121 WE  Aalten"]
["Tel: 0543-472292 / 06-40263789",null,null,null,null,"Tel: 0543-474166 / 06-20677773"]
["j.jansink2016@gmail.com",null,null,null,null,"marco.ubbink@gmail.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"made by Marco Ubbink"]